Edition-Based Redefinition (EBR) was often described as the “killer feature” of Oracle 11gR2 it has been enhanced in Oracle 12c. This session will explore the concepts of EBR and planning for EBR implementation. Specific topics include: Changes in 12c, Edition objects, Editioning Views, and Cross-Edition triggers. A brief demonstration will highlight the basics of EBR.…

Attendees are introduced to new and improved features of Oracle 12c directly impacting application development. Special emphasis is given to features that reduce development time, make development simpler, improve performance, or speed deployment. Specific topics include: IDENTITY columns, improved SEQUENCEs, INVISIBLE columns, improved defaults, JSON enablement, APPROX_COUNT_DISTINCT function, security enhancements, PL/SQL interoperability improvements, outer-join improvements,…

Migration of databases to cross-platforms is becoming a necessity these days because of cloud computing and the need for deploying onto hosting company data centers.  The key is using of RMAN’s cross-platform backup and restore technique, an important RMAN feature of Oracle 12c.  When incremental-based backup and restore approach is used, the migration time can…

Attendees are introduced to new and improved features of Oracle 12c directly impacting application development. Special emphasis is given to features that reduce development time, make development simpler, improve performance, or speed deployment. Specific topics include: IDENTITY columns, improved SEQUENCEs, INVISIBLE columns, improved defaults, JSON enablement, APPROX_COUNT_DISTINCT function, security enhancements, PL/SQL interoperability improvements, outer-join improvements,…

Many organizations struggle to control server expansion while faced with expanding business needs and security requirements while maintaining operational effectiveness. Oracle has enhanced Oracle Enterprise Manager 12c to allow organizations to automate security compliance while ensuring business agility. In this session, you will learn how to identify, configure and implement security compliance within Oracle Enterprise…

Original Broadcast: April 27, 2017 As DBAs already know, storage responsiveness is critical to database performance. Unfortunately, most storage arrays are unaware of database workload requirements and treat all I/Os the same. To solve these challenges, Oracle Intelligent Storage Protocol (OISP) was introduced with Oracle Database 12c With OISP, the database sends hints to Oracle…

As many DBAs adopt Enterprise Manager 12c, they become aware that the product is more of a self service product than "plug-n-play". This session will cover the basics of a six part series on Enterprise Manager 12c, along with many aspects from Apress' Expert Enterprise Manager 12c the presenter was co-author on. Special emphasis will…

Oracle Enterprise Manager 12c is one of the most versatile manageability tool in the market helping enterprises to monitor and enabling Application-to-Disk management  through a single pane of glass for all data center components.As an Enterprise Manager administrator you are responsible of a wide variety of tasks including discovering and maintaining targets, deploying plugins, tuning…

Cloud Control 12c allows Ithaka Harbors to manage its infrastructure, databases and applications (oracle and non-oracle).  This presentation will provide recipes on installing cloud control, setting up groups, plugins, monitoring, notification, security, rules and how to setup up automated routine tasks, and provided reporting capabilities on the history and trends.

This presentation will look at which 12c tuning features should be investigated for use.  Many of the tuning features that will be covered will be related to the DBA, but there will also be a few outside that realm that focus on the developer.  There will be simple examples (such as a quick example using…